package com.yun.zf.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yun.zf.common.admin.domain.ZfPactRentInfo;
import com.yun.zf.common.admin.model.pact.PactRentInfoMo;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 合同房源信息 Mapper 接口
 * </p>
 *
 * @author cj
 * @since 2021-07-24
 */
public interface ZfPactRentInfoMapper extends BaseMapper<ZfPactRentInfo> {

    @Select("<script>" +
            " SELECT pact_id, use_type,start_time,end_time,rent_amount , frequency ,pay_type,deposit,is_zx,remarks,party_a,party_b,implement,max_renter from  zf_pact_rent_info r " +
            " WHERE r.pact_id =#{pactId} and city_code=#{cityCode} and province_code=#{provCode}  " +
            "</script>")
    PactRentInfoMo getRent(Long provCode, Long cityCode, Long pactId);
}
